String url = ...
Connection con = DriverManager.getConnection(url);


// cursor shared
stmt = con.createStatement();
// Com fetchSize igual a zero todas as linhas do result set irão ser colocadas em cache.
stmt.setFetchSize(0);
stmt.executeQuery(sqlQuery);

ResultSet cursor = ((ICStatement) stmt).getCursor();

// cursor individual 
stmt = con.createStatement();
// Cache individual com capacidade igual a 25 linhas.
stmt.setFetchSize(25);
stmt.executeQuery(sqlQuery);

ResultSet cursor = ((ICStatement) stmt).getCursor();


